UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XakYqXBCDwu2WXuRp/Fw9wrvrF7+Nhlc/ykkoGxcymw='
WHERE
key_id = 'ff191577a06366caa0a1267bbf63c97c0d02b94f683693d59813ab317ef193be'
AND (
token = 'XakYqXBCDwu2WXuRp/Fw9wrvrF7+Nhlc/ykkoGxcymw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)