UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0lh1j8QMQo/J981BueJ5wOgj3LhRez9bYjSQ7oERkqg='
WHERE
key_id = 'd0978b7b98531c4f4244cb68cddfa8f6186eb7a402ca77dc6c0423a0c5989ed2'
AND (
token = '0lh1j8QMQo/J981BueJ5wOgj3LhRez9bYjSQ7oERkqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)