UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BIInEpZDaQDVVXTKYX8wBH8TgJmMk1Cvn9m2D3pRRBA='
WHERE
key_id = 'dbb9bcca364930a35a439ab877befd13108b3470f3d46a03554de38e69287c10'
AND (
token = 'BIInEpZDaQDVVXTKYX8wBH8TgJmMk1Cvn9m2D3pRRBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)