UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'caEmPUrI5RTx5aRFERjNo1exT0RUD68ErdJA03qgZ00='
WHERE
key_id = '224b8e1638d6a298b3e94ec1fbad7e846e92ad90c255559e4cbf7ff25e16dab2'
AND (
token = 'caEmPUrI5RTx5aRFERjNo1exT0RUD68ErdJA03qgZ00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)