UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCONPvP8A1LKVgwGdatMYIkEo1QMUOqrspaMMmGCPbk='
WHERE
key_id = '5e26520df514dafae773585e21985cfd0351e46c92184c0bb66409d0c9706ea6'
AND (
token = 'pCONPvP8A1LKVgwGdatMYIkEo1QMUOqrspaMMmGCPbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)