UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Mx3Ca7X6vNi/qtmlY7SpNVAYmdsB4hydgg8i2i7Mr0='
WHERE
key_id = 'f7126686e8e604466a2add16a830f9802f5761cc95557d91e91b95b07a0b894d'
AND (
token = '1Mx3Ca7X6vNi/qtmlY7SpNVAYmdsB4hydgg8i2i7Mr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)