UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9iXSFW+cPNVGNDbrWi58I7y2RHw9zPvtpBmjPMWanw='
WHERE
key_id = 'ea53877d9cb67969c5c245c0def10edc143dfbb0c647815ac9c4be7153a4b8a5'
AND (
token = 'U9iXSFW+cPNVGNDbrWi58I7y2RHw9zPvtpBmjPMWanw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)