UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1/LS2DizT0+iRjm0tGCNFyVzi+Zp+ni8GI9Pnifj8Y='
WHERE
key_id = 'de678ad4b3fc28a1f74608bf8852e25926f5bedd84919e05cd36b46d29490661'
AND (
token = 'W1/LS2DizT0+iRjm0tGCNFyVzi+Zp+ni8GI9Pnifj8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)