UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CgjSSY/5kIXPa3UVKrUbf5nn1BoOnRLP3lrYMy9DAs='
WHERE
key_id = 'b29469cb14b45b55fad520d218102b994d121db99c7c4cfeb9926a039c233417'
AND (
token = '8CgjSSY/5kIXPa3UVKrUbf5nn1BoOnRLP3lrYMy9DAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)