UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fosIrFO+AfWtD74nJEZHqSMMSpivxBZr5OUwr7j6jxw='
WHERE
key_id = '05f9e6a4b0bbdecd445597fa4a85fb44ca34d2d8d4b09444e5095edd0f1a56fa'
AND (
token = 'fosIrFO+AfWtD74nJEZHqSMMSpivxBZr5OUwr7j6jxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)