UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '01AU1m+hyalGldICZFM84eIyzSxgrRrOe8IoSWd28Os='
WHERE
key_id = '77b313d430f85524cf028a70a46c92a7bd6bd0772ac8312cf101ca97204f0015'
AND (
token = '01AU1m+hyalGldICZFM84eIyzSxgrRrOe8IoSWd28Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)