UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dRgdQ8PGJJ1IKd6BkPgfo/E6VL9t3940ypvNQzSaec0='
WHERE
key_id = '05ca975a92ad695a8cdb2409623305127a55899b7af46eca6723c939e8640d71'
AND (
token = 'dRgdQ8PGJJ1IKd6BkPgfo/E6VL9t3940ypvNQzSaec0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)