UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z8JBaf1QGjdKZ5qV7uM2TYuca+eW9H8Yw1rpwbAelKw='
WHERE
key_id = '417c651eb13ae7c8a2eb6c32a8147037340872b925f81f0535bee11f31747afe'
AND (
token = 'Z8JBaf1QGjdKZ5qV7uM2TYuca+eW9H8Yw1rpwbAelKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)