UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aglzK1VW44VwKlYdxkyfbWx7sYfUdeRMniBI0j1f78='
WHERE
key_id = '0da06438b97fb26c44a226ee51db7d28e164cae5ebf1464270cfcb17aa1d0f14'
AND (
token = '7aglzK1VW44VwKlYdxkyfbWx7sYfUdeRMniBI0j1f78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)