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