UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/xghBVwvO0lyDistmc1AmW/4szRdJfao+9jCRj0Z28w='
WHERE
key_id = '31af78336a2731a73a066113b6ff6acebfa7037e2eed36728c2aeca911a69e10'
AND (
token = '/xghBVwvO0lyDistmc1AmW/4szRdJfao+9jCRj0Z28w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)