UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xzQU1Yi9wqJSkz/W/VoedKVxzan3jaiFYa3K+qwvM0='
WHERE
key_id = '896b5b74889dad0198dd04bd6988de428ef2849c8cafa618f96e02cc002f3e89'
AND (
token = '0xzQU1Yi9wqJSkz/W/VoedKVxzan3jaiFYa3K+qwvM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)