UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UQC0A7lbO6h8kW9owDcmq2fq8DhXbqfiWISU55Gdx4w='
WHERE
key_id = 'c2f7a1cd31f85646d7a43c16ca465a4ddb0b3ec81265d5645c03fbfce6c1a619'
AND (
token = 'UQC0A7lbO6h8kW9owDcmq2fq8DhXbqfiWISU55Gdx4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)