UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mLS7bNbkt8ftyX84CpeYVUmQgB+O2B+F7CS8jlxPBd4='
WHERE
key_id = 'de63f2e15333431a1cf85cad635f18689240f6feb51858e0a61edcdf95c617b4'
AND (
token = 'mLS7bNbkt8ftyX84CpeYVUmQgB+O2B+F7CS8jlxPBd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)