UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4QCYzIQy06LR0g9k0lXZO6kHUXIuPb+j/cihB16qmyg='
WHERE
key_id = '3343ebe2b3f23c4bae97f425184f8acb0af14ba94bd757bf5b84685a151a7fae'
AND (
token = '4QCYzIQy06LR0g9k0lXZO6kHUXIuPb+j/cihB16qmyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)