UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0XxWLoXmBrw7Htuh9ki2L2pHYsuLXqaP0K87XnrL2rs='
WHERE
key_id = '4848af39348d7bdf71a028a2edb3ebb3a428c59b7a11d1ce4958c26516403863'
AND (
token = '0XxWLoXmBrw7Htuh9ki2L2pHYsuLXqaP0K87XnrL2rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)