UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8/0xp8PDUW66LHelSbeWpsLY5OB0N/t4YecgqYIjoUw='
WHERE
key_id = 'f418bf6da858c839f7a1444426b8fe55d0b7a4f8f32ab2d179d697735aab647b'
AND (
token = '8/0xp8PDUW66LHelSbeWpsLY5OB0N/t4YecgqYIjoUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)