UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzK/30EPwHfMX9Od3HR6CtekL+V+sCw07zLNdG8VweM='
WHERE
key_id = '09be1322acf60d0a296b17500f5ef99ff06feba70a54f3eb88608fb156e0f9b4'
AND (
token = 'XzK/30EPwHfMX9Od3HR6CtekL+V+sCw07zLNdG8VweM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)