UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ofIRuLIBl147KVG+SUH8dcxKmpABt8iSgO6u81a8Cw='
WHERE
key_id = '38641011cc5106d7b24d6ebdca33794dda6477ef24e825ea37d109115d6cc293'
AND (
token = '8ofIRuLIBl147KVG+SUH8dcxKmpABt8iSgO6u81a8Cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)