UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zy9J6MDuMc5B1gF4iWRtwIFGklbUE+1wrJUUy4HvLJ4='
WHERE
key_id = '7aa873cd710a96cf220bed69a26fa8878a16b1350b761baa06401d196303b239'
AND (
token = 'Zy9J6MDuMc5B1gF4iWRtwIFGklbUE+1wrJUUy4HvLJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)