UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yBb39k4hOGJtWIHti6+/GO2hDm2UcppTJIoVBItzhtU='
WHERE
key_id = 'e46245631e772699fd20dc6743e1debc893a1d328323378dadef066791e81ce5'
AND (
token = 'yBb39k4hOGJtWIHti6+/GO2hDm2UcppTJIoVBItzhtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)