UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcJC9xCPrGJTy87mvDh8ccNuqKnhfdTbPWfSG7OKTpQ='
WHERE
key_id = '806a590b0db71375f0fcee38782c6a8fa8d77593260e277fc20e29a6f7d9d9c4'
AND (
token = 'mcJC9xCPrGJTy87mvDh8ccNuqKnhfdTbPWfSG7OKTpQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)