UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Hvs7g6NRQQBzCkfrVav+hhmiGvM0Y+6KZN3bGS6oVE='
WHERE
key_id = '54ef301ad3cd5fb840f66a243c0316ba20061ccfac47a20a9637b900a9a3475a'
AND (
token = '5Hvs7g6NRQQBzCkfrVav+hhmiGvM0Y+6KZN3bGS6oVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)