UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWG/wHkyPij6QzGt3GkQa4DrOeJGhqG7fGvCLd54/TA='
WHERE
key_id = 'dec9ce25097d64ba664c1c404019759e8aee5646b3c7151e3634571ead577d90'
AND (
token = 'VWG/wHkyPij6QzGt3GkQa4DrOeJGhqG7fGvCLd54/TA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)