UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F0R3/Rdh0cJdenvdEivZhYbSNrEaRAD+jCKVJ1plRdM='
WHERE
key_id = 'd167fac9ba3ea66a84463186436b900062fc5afdce594782d89dc8b8782a0d87'
AND (
token = 'F0R3/Rdh0cJdenvdEivZhYbSNrEaRAD+jCKVJ1plRdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)