UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uWfIr1drWaa0XZigbRDFDbzyy5Fd3uLxevFy4NHmZrc='
WHERE
key_id = '37d83ee9e7831069d7a0d08d7e229fc40c0369c40d9b25badb8b4be17a4fb11a'
AND (
token = 'uWfIr1drWaa0XZigbRDFDbzyy5Fd3uLxevFy4NHmZrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)