UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PJtfJOIXq+YgPuytk1ZqQjV7PwnkE5CvRh/w58mwSas='
WHERE
key_id = 'ab8bd885afdcd0f6c18837d9c4eab66f170adf3c8f5139d09e8ff2460459df6b'
AND (
token = 'PJtfJOIXq+YgPuytk1ZqQjV7PwnkE5CvRh/w58mwSas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)