UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lrUEHrhWMmQYgzWi0k/CUqiAASnpJychUDxwwNoAl9o='
WHERE
key_id = 'fecd7df2fa42e52767d9aff9bba7e2d6d5fe43e2f47ab64217f89155fb2f403f'
AND (
token = 'lrUEHrhWMmQYgzWi0k/CUqiAASnpJychUDxwwNoAl9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)