UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1xBSfk780zV1v25LgHE5TsqmWSKXt95mMfxnn9hQIlU='
WHERE
key_id = 'd3c6afc34a2d75dd309793cb6ddc148f53be563618636de1a3f30598898c849e'
AND (
token = '1xBSfk780zV1v25LgHE5TsqmWSKXt95mMfxnn9hQIlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)