UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z5Qchh3eWBoeWk9pnIpUZrtjT9elzMDo5BSOmx8pBlE='
WHERE
key_id = '9c06fd3cd07cc1f9ce8d69f0fca8a2c3ce4349e19ee5db8b616d12ac880c9ddb'
AND (
token = 'z5Qchh3eWBoeWk9pnIpUZrtjT9elzMDo5BSOmx8pBlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)