UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sDCvmtd1uqOtJFc8cnN/AwVJ4io7gyGy/W4r6mZCVEU='
WHERE
key_id = 'bd69da5961a5e49d11a7491baedef4af46d0d6b380e836fba49a22751ff131a1'
AND (
token = 'sDCvmtd1uqOtJFc8cnN/AwVJ4io7gyGy/W4r6mZCVEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)