UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0mS8yPppq/GFgqi8yoWFplxXokprlfmmJ6bAXll/Lnk='
WHERE
key_id = '788c73614ab9d71fa1ae273b9a594e6a6da30449ff52024999fd657f79c9dbab'
AND (
token = '0mS8yPppq/GFgqi8yoWFplxXokprlfmmJ6bAXll/Lnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)